﻿using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;

// Code scaffolded by EF Core assumes nullable reference types (NRTs) are not used or disabled.
// If you have enabled NRTs for your project, then un-comment the following line:
// #nullable disable

namespace DataWasher.WebApi.Entities
{
    public partial class MyDbConetxt : DbContext
    {
        public MyDbConetxt()
        {
        }

        public MyDbConetxt(DbContextOptions<MyDbConetxt> options)
            : base(options)
        {
        }

        public virtual DbSet<BaseDatadict> BaseDatadict { get; set; }
        public virtual DbSet<Businesscategory> Businesscategory { get; set; }
        public virtual DbSet<Costrecord> Costrecord { get; set; }
        public virtual DbSet<Costrecordextra> Costrecordextra { get; set; }
        public virtual DbSet<SysBasestorebrand> SysBasestorebrand { get; set; }
        public virtual DbSet<SysMultilingual> SysMultilingual { get; set; }
        public virtual DbSet<SysRelation> SysRelation { get; set; }
        public virtual DbSet<VmMntcategory> VmMntcategory { get; set; }
        public virtual DbSet<VmMntorder> VmMntorder { get; set; }
        public virtual DbSet<VmMntproblem> VmMntproblem { get; set; }
        public virtual DbSet<VmMntrequest> VmMntrequest { get; set; }
        public virtual DbSet<VmMntrequestdetail> VmMntrequestdetail { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseMySql("server=127.0.0.1;uid=root;port=3308;pwd=123456;database=maintenancedb", x => x.ServerVersion("10.5.9-mariadb"));
            }
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<BaseDatadict>(entity =>
            {
                entity.HasKey(e => e.DataDictId)
                    .HasName("PRIMARY");

                entity.ToTable("base_datadict");

                entity.HasIndex(e => e.DataDictId)
                    .HasName("Index_base_DataDict_PK")
                    .IsUnique();

                entity.HasIndex(e => e.IsDeleted)
                    .HasName("Index_base_DataDict_IsDeleted");

                entity.HasIndex(e => e.OwnerId)
                    .HasName("Index_base_DataDict_OwnerID");

                entity.HasIndex(e => e.SyncKey)
                    .HasName("Index_base_DataDict_SyncKey");

                entity.HasIndex(e => new { e.OwnerId, e.IsDeleted, e.SyncKey })
                    .HasName("OwnerId, IsDeleted, SyncKey");

                entity.Property(e => e.DataDictId)
                    .HasColumnName("DataDictID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DataCode)
                    .HasColumnType("varchar(20)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DataName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DataNameEn)
                    .HasColumnName("DataName_EN")
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DataNameMl)
                    .HasColumnName("DataName_ML")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("维修数据字典名称-多语言")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DataType)
                    .HasColumnType("varchar(20)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Datavalue)
                    .HasColumnName("datavalue")
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.IsHighlight)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("优先级是否高亮显示");

                entity.Property(e => e.OwnerId)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SortNo)
                    .HasColumnType("varchar(20)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SyncKey).HasColumnType("bigint(20)");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime(3)");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<Businesscategory>(entity =>
            {
                entity.ToTable("businesscategory");

                entity.Property(e => e.Id)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AccountCode)
                    .HasColumnType("varchar(255)")
                    .HasComment("财务账号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AccountName)
                    .HasColumnType("varchar(255)")
                    .HasComment("财务名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Category)
                    .HasColumnType("varchar(255)")
                    .HasComment("保修业务分类")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.CostType)
                    .HasColumnType("varchar(255)")
                    .HasComment("成本类型")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted).HasColumnType("int(255)");

                entity.Property(e => e.OwnerId)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<Costrecord>(entity =>
            {
                entity.ToTable("costrecord");

                entity.Property(e => e.Id)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .IsRequired()
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.CategoryId)
                    .HasColumnType("varchar(36)")
                    .HasComment("分类")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Cost)
                    .HasColumnType("decimal(20,6)")
                    .HasComment("成本");

                entity.Property(e => e.CurrencyType)
                    .HasColumnType("int(255)")
                    .HasComment("货币类型");

                entity.Property(e => e.FinishedTime)
                    .HasColumnType("datetime")
                    .HasComment("完成时间");

                entity.Property(e => e.IsDeleted).HasColumnType("int(255)");

                entity.Property(e => e.MntClassification)
                    .HasColumnType("int(255)")
                    .HasComment("维修类型");

                entity.Property(e => e.Mrdid)
                    .HasColumnName("MRDID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修申请ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OrderId)
                    .IsRequired()
                    .HasColumnType("varchar(36)")
                    .HasComment("订单id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Quotation)
                    .HasColumnType("varchar(500)")
                    .HasDefaultValueSql("''")
                    .HasComment("询价单号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Tax)
                    .HasColumnType("decimal(20,6)")
                    .HasComment("税项");

                entity.Property(e => e.TaxCurrencyType)
                    .HasColumnType("int(11)")
                    .HasComment("税项货币");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime");

                entity.Property(e => e.UpdateUserId)
                    .IsRequired()
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<Costrecordextra>(entity =>
            {
                entity.ToTable("costrecordextra");

                entity.Property(e => e.Id)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AccountCode)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AccountName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.BrandNameCn)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Category)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Cost).HasColumnType("decimal(12,6)");

                entity.Property(e => e.CostType)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.CurrencyTypeDes)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DomainLv1)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DomainLv2)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Eurcost)
                    .HasColumnName("EURCost")
                    .HasColumnType("decimal(12,6)");

                entity.Property(e => e.ExchangeRate).HasColumnType("decimal(12,6)");

                entity.Property(e => e.FinishedTime).HasColumnType("datetime");

                entity.Property(e => e.MntCategory)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntClassificationDes)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntContent)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntStatusDes)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerId)
                    .HasColumnType("varchar(100)")
                    .HasComment("订单id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Pcdes)
                    .HasColumnName("PCDes")
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemData)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Quotation)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreCode)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.TypeName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<SysBasestorebrand>(entity =>
            {
                entity.ToTable("sys_basestorebrand");

                entity.HasIndex(e => e.StoreId)
                    .HasName("StoreID");

                entity.Property(e => e.Id)
                    .HasColumnName("ID")
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.BrandNameCn)
                    .HasColumnName("BrandNameCN")
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DomainId)
                    .HasColumnName("DomainID")
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DomainName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DomainTag)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Market)
                    .HasColumnType("varchar(500)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ParentDomainId)
                    .HasColumnName("ParentDomainID")
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreId)
                    .HasColumnName("StoreID")
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.TagName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.TypeName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<SysMultilingual>(entity =>
            {
                entity.HasKey(e => e.MultiLingualId)
                    .HasName("PRIMARY");

                entity.ToTable("sys_multilingual");

                entity.HasIndex(e => e.FieldId)
                    .HasName("Index_Sys_MultiLingual__FieldId");

                entity.HasIndex(e => e.OwnerId)
                    .HasName("Index_Sys_MultiLingual__OwnerID");

                entity.HasIndex(e => new { e.FieldId, e.IsDeleted })
                    .HasName("FieldId, IsDeleted");

                entity.Property(e => e.MultiLingualId)
                    .HasColumnType("varchar(36)")
                    .HasComment("多语言主键Id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Content)
                    .HasColumnType("varchar(500)")
                    .HasDefaultValueSql("''")
                    .HasComment("内容")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.FieldFrom)
                    .HasColumnType("varchar(100)")
                    .HasDefaultValueSql("''")
                    .HasComment("字段来自那张表")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.FieldId)
                    .IsRequired()
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("多语言字段Id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否删除");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("公司Id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerLanguage)
                    .HasColumnType("int(4)")
                    .HasComment("多语言：0简体中文 1繁体 2英文 3日文");
            });

            modelBuilder.Entity<SysRelation>(entity =>
            {
                entity.HasKey(e => e.RelationId)
                    .HasName("PRIMARY");

                entity.ToTable("sys_relation");

                entity.HasComment("供应商");

                entity.HasIndex(e => e.RelationId)
                    .HasName("RelationId")
                    .IsUnique();

                entity.HasIndex(e => new { e.ClientId, e.SyncKey })
                    .HasName("ClientId, SyncKey");

                entity.Property(e => e.RelationId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate)
                    .HasColumnType("datetime")
                    .HasComment("添加日期");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("添加用户")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientAlias)
                    .HasColumnType("varchar(100)")
                    .HasDefaultValueSql("''")
                    .HasComment("甲方别名")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientContact)
                    .HasColumnType("varchar(50)")
                    .HasComment("甲方联系人")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientContactPhone)
                    .HasColumnType("varchar(50)")
                    .HasComment("甲方联系人电话")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientEmail)
                    .HasColumnType("varchar(50)")
                    .HasComment("甲方邮箱")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("甲方ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientName)
                    .HasColumnType("varchar(50)")
                    .HasComment("甲方公司名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ClientRemark)
                    .HasColumnType("varchar(500)")
                    .HasComment("甲方备注")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ContactPerson)
                    .HasColumnType("varchar(50)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商联系人")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ContactPhone)
                    .HasColumnType("varchar(50)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商联系电话")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Email)
                    .HasColumnType("varchar(100)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商邮箱")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否删除");

                entity.Property(e => e.IsFrozen)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否冻结");

                entity.Property(e => e.IsLimitDomain)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否限制组织");

                entity.Property(e => e.IsLimitMntCategory)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否限制维修类别");

                entity.Property(e => e.NeedCompleteReport)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'1'")
                    .HasComment("需要完工报告");

                entity.Property(e => e.Remark)
                    .HasColumnType("varchar(500)")
                    .HasComment("供应商备注")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ServiceId)
                    .HasColumnType("varchar(50)")
                    .HasComment("供应商服务ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Status)
                    .HasColumnType("int(2)")
                    .HasComment("供应商状态: 1待审核 2已通过 3甲方进行冻结 4已拒绝 5已删除 6乙方进行冻结 7乙方进行删除");

                entity.Property(e => e.SyncKey)
                    .HasColumnType("bigint(20)")
                    .HasDefaultValueSql("'0'")
                    .HasComment("同步键");

                entity.Property(e => e.UpdateDate)
                    .HasColumnType("datetime(3)")
                    .HasComment("更新日期");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("更新用户ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorAlias)
                    .HasColumnType("varchar(100)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorName)
                    .HasColumnType("varchar(50)")
                    .HasComment("供应商公司名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorType)
                    .HasColumnType("varchar(20)")
                    .HasDefaultValueSql("''")
                    .HasComment("供应商类型")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<VmMntcategory>(entity =>
            {
                entity.HasKey(e => e.Mcid)
                    .HasName("PRIMARY");

                entity.ToTable("vm_mntcategory");

                entity.HasIndex(e => e.IsDeleted)
                    .HasName("Index_VM_MntCategory_IsDeleted");

                entity.HasIndex(e => e.Mcid)
                    .HasName("Index_VM_MntCategory_PK")
                    .IsUnique();

                entity.HasIndex(e => e.OwnerId)
                    .HasName("Index_VM_MntCategory_OwnerID");

                entity.HasIndex(e => e.ParentId)
                    .HasName("ParentID");

                entity.HasIndex(e => e.SyncKey)
                    .HasName("Index_VM_MntCategory_SyncKey");

                entity.HasIndex(e => new { e.Mcid, e.ParentId })
                    .HasName("MCID, ParentID");

                entity.HasIndex(e => new { e.Mcid, e.ParentId, e.IsDeleted })
                    .HasName("MCID, ParentID, IsDeleted");

                entity.Property(e => e.Mcid)
                    .HasColumnName("MCID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修分类ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AutoApproval)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("自动审批");

                entity.Property(e => e.CategoryCode).HasColumnType("int(11)");

                entity.Property(e => e.CategoryMemo)
                    .HasColumnType("varchar(200)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.CategoryMemoEn)
                    .HasColumnName("CategoryMemo_EN")
                    .HasColumnType("varchar(200)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.CategoryMemoMl)
                    .HasColumnName("CategoryMemo_ML")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("维修分类名称-多语言")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DefaultPriority)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("默认优先级")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DefaultVendor)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("默认供应商")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.IsEnable)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'1'")
                    .HasComment("是否启用");

                entity.Property(e => e.Level)
                    .HasColumnType("int(11)")
                    .HasDefaultValueSql("'0'");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ParentId)
                    .HasColumnName("ParentID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Pcid)
                    .HasColumnName("PCID")
                    .HasColumnType("varchar(4000)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SyncKey)
                    .HasColumnType("bigint(20)")
                    .HasDefaultValueSql("'0'");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime(3)");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorName)
                    .HasColumnType("varchar(100)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<VmMntorder>(entity =>
            {
                entity.HasKey(e => e.Moid)
                    .HasName("PRIMARY");

                entity.ToTable("vm_mntorder");

                entity.HasIndex(e => e.StoreId)
                    .HasName("index_StoreID");

                entity.HasIndex(e => new { e.OwnerId, e.IsDeleted })
                    .HasName("index_IsDeleted_OwnerId");

                entity.Property(e => e.Moid)
                    .HasColumnName("MOID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.IsFinish).HasColumnType("int(11)");

                entity.Property(e => e.IsMrp)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否维保计划");

                entity.Property(e => e.IsNew).HasColumnType("bit(1)");

                entity.Property(e => e.LastDecorateDate).HasColumnType("date");

                entity.Property(e => e.MoCode)
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Mrpid)
                    .HasColumnName("MRPID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维保计划批次号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreId)
                    .HasColumnName("StoreID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SyncKey).HasColumnType("bigint(20)");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorId)
                    .HasColumnName("VendorID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<VmMntproblem>(entity =>
            {
                entity.HasKey(e => e.Mpid)
                    .HasName("PRIMARY");

                entity.ToTable("vm_mntproblem");

                entity.HasIndex(e => e.IsDeleted)
                    .HasName("Index_VM_MntProblem_IsDeleted");

                entity.HasIndex(e => e.Mpid)
                    .HasName("Index_VM_MntProblem_PK")
                    .IsUnique();

                entity.HasIndex(e => e.OwnerId)
                    .HasName("Index_VM_MntProblem_OwnerID");

                entity.HasIndex(e => e.SyncKey)
                    .HasName("Index_VM_MntProblem_SyncKey");

                entity.Property(e => e.Mpid)
                    .HasColumnName("MPID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修问题")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.DefaultPriority)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("默认优先级")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Pcid)
                    .HasColumnName("PCID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemMemo)
                    .HasColumnType("varchar(200)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemMemoEn)
                    .HasColumnName("ProblemMemo_EN")
                    .HasColumnType("varchar(200)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemMemoMl)
                    .HasColumnName("ProblemMemo_ML")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("维修故障名称-多语言")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SortNo).HasColumnType("int(11)");

                entity.Property(e => e.SyncKey)
                    .HasColumnType("bigint(20)")
                    .HasDefaultValueSql("'0'");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime(3)");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<VmMntrequest>(entity =>
            {
                entity.HasKey(e => e.Mrid)
                    .HasName("PRIMARY");

                entity.ToTable("vm_mntrequest");

                entity.HasIndex(e => e.AddUserId)
                    .HasName("AddUserId")
                    .IsUnique();

                entity.HasIndex(e => e.Mrid)
                    .HasName("MRID")
                    .IsUnique();

                entity.HasIndex(e => e.StoreId)
                    .HasName("StoreID");

                entity.Property(e => e.Mrid)
                    .HasColumnName("MRID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AddDate).HasColumnType("datetime");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.IsMrp)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否维保计划");

                entity.Property(e => e.Mrcode)
                    .HasColumnName("MRCode")
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MrpBatch)
                    .HasColumnType("varchar(255)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Mrpid)
                    .HasColumnName("MRPID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维保计划批次号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerId)
                    .IsRequired()
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Pdfurl)
                    .HasColumnName("PDFUrl")
                    .HasColumnType("text")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.RequestDate).HasColumnType("datetime");

                entity.Property(e => e.StoreAddress)
                    .HasColumnType("varchar(500)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreContact)
                    .HasColumnType("varchar(20)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreContactPhone)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreId)
                    .HasColumnName("StoreID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.StoreName)
                    .HasColumnType("varchar(200)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.SyncKey).HasColumnType("bigint(20)");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime(3)");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.UserId)
                    .IsRequired()
                    .HasColumnName("UserID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.UserName)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            modelBuilder.Entity<VmMntrequestdetail>(entity =>
            {
                entity.HasKey(e => e.Mrdid)
                    .HasName("PRIMARY");

                entity.ToTable("vm_mntrequestdetail");

                entity.HasIndex(e => e.Mcid)
                    .HasName("MCID");

                entity.HasIndex(e => e.Moid)
                    .HasName("index_MOID");

                entity.HasIndex(e => e.Mrdid)
                    .HasName("UK_vm_mntrequestdetail_MRDID")
                    .IsUnique();

                entity.HasIndex(e => e.Mrid)
                    .HasName("MRID");

                entity.HasIndex(e => e.SyncKey)
                    .HasName("SyncKey");

                entity.HasIndex(e => new { e.Mrid, e.Mcid })
                    .HasName("MRID, MCID");

                entity.Property(e => e.Mrdid)
                    .HasColumnName("MRDID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修IssueID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.AcceptanceDate)
                    .HasColumnType("datetime")
                    .HasComment("验收日期");

                entity.Property(e => e.AddDate)
                    .HasColumnType("datetime")
                    .HasComment("申请时间");

                entity.Property(e => e.AddUserId)
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ApproveDate)
                    .HasColumnType("datetime")
                    .HasComment("审核时间");

                entity.Property(e => e.ApproveFlowDate).HasColumnType("datetime");

                entity.Property(e => e.CompleteDate).HasColumnType("datetime");

                entity.Property(e => e.ContactInfo)
                    .HasColumnType("varchar(2000)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.IsDeleted)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'");

                entity.Property(e => e.IsEnquiry)
                    .HasColumnType("bit(1)")
                    .HasComment("是否可以询价");

                entity.Property(e => e.IsMrp)
                    .HasColumnType("bit(1)")
                    .HasDefaultValueSql("b'0'")
                    .HasComment("是否维保计划");

                entity.Property(e => e.IsNew).HasColumnType("bit(1)");

                entity.Property(e => e.IsWarrantyPeriod)
                    .HasColumnType("bit(1)")
                    .HasComment("是否保养期");

                entity.Property(e => e.IssueImage)
                    .HasColumnType("varchar(5000)")
                    .HasComment("问题图片")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MaintainerMntDate).HasColumnType("datetime");

                entity.Property(e => e.Mcid)
                    .HasColumnName("MCID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修类别Id")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntCategory)
                    .HasColumnType("varchar(500)")
                    .HasComment("维修类别名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntContent)
                    .HasColumnType("varchar(500)")
                    .HasComment("维修问题说明")
                    .HasCharSet("utf8mb4")
                    .HasCollation("utf8mb4_general_ci");

                entity.Property(e => e.MntDate)
                    .HasColumnType("varchar(100)")
                    .HasComment("施工完成时间")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntFullCategory)
                    .HasColumnType("varchar(500)")
                    .HasComment("完整维修类别")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MntStatus)
                    .HasColumnType("varchar(100)")
                    .HasComment("状态")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Moid)
                    .HasColumnName("MOID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修订单ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Mrdcode)
                    .HasColumnName("MRDCode")
                    .HasColumnType("varchar(50)")
                    .HasComment("Issue编号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Mrid)
                    .HasColumnName("MRID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维修申请ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.MrpBatch)
                    .HasColumnType("varchar(100)")
                    .HasCharSet("utf8mb4")
                    .HasCollation("utf8mb4_general_ci");

                entity.Property(e => e.Mrpid)
                    .HasColumnName("MRPID")
                    .HasColumnType("varchar(36)")
                    .HasComment("维保计划批次号")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.OwnerId)
                    .HasColumnName("OwnerID")
                    .HasColumnType("varchar(36)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PdfUrl)
                    .HasColumnType("varchar(500)")
                    .HasComment("维修项pdf路径")
                    .HasCharSet("utf8mb4")
                    .HasCollation("utf8mb4_general_ci");

                entity.Property(e => e.PlanDate)
                    .HasColumnType("datetime")
                    .HasComment("计划上门时间");

                entity.Property(e => e.PostCondition1)
                    .HasColumnType("varchar(5)")
                    .HasComment("状态1")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PostCondition2)
                    .HasColumnType("varchar(5)")
                    .HasComment("状态2")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PostCondition3)
                    .HasColumnType("varchar(5)")
                    .HasComment("状态3")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PostCondition4)
                    .HasColumnType("varchar(5)")
                    .HasComment("状态4")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Priority)
                    .HasColumnType("varchar(50)")
                    .HasComment("优先级名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PriorityName)
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.PriorityNameEn)
                    .HasColumnName("PriorityName_EN")
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemCoordinate)
                    .HasColumnType("varchar(5000)")
                    .HasComment("问题位置JsonData")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemData)
                    .HasColumnType("varchar(5000)")
                    .HasComment("维修问题列表JsonData")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ProblemIds)
                    .HasColumnType("varchar(1000)")
                    .HasComment("维修问题Id列表")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ReceivingDate).HasColumnType("datetime");

                entity.Property(e => e.ReferenceId)
                    .HasColumnName("ReferenceID")
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasComment("返修ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.RelationMrdid)
                    .HasColumnName("RelationMRDID")
                    .HasColumnType("varchar(36)")
                    .HasComment("关联的MRDID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.Score)
                    .HasColumnType("int(11)")
                    .HasComment("维修质量得分");

                entity.Property(e => e.Score1)
                    .HasColumnType("int(11)")
                    .HasComment("维修速度得分");

                entity.Property(e => e.Score2)
                    .HasColumnType("int(11)")
                    .HasComment("服务态度得分");

                entity.Property(e => e.SendEmailTime)
                    .HasColumnType("datetime")
                    .HasComment("最后一次发送邮件的时间");

                entity.Property(e => e.Settlement).HasColumnType("decimal(18,2)");

                entity.Property(e => e.SyncKey).HasColumnType("bigint(20)");

                entity.Property(e => e.TaskingDate)
                    .HasColumnType("datetime")
                    .HasComment("派工时间");

                entity.Property(e => e.ThumbFileId)
                    .HasColumnName("ThumbFileID")
                    .HasColumnType("varchar(200)")
                    .HasComment("Issue头像")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.UpdateDate).HasColumnType("datetime(3)");

                entity.Property(e => e.UpdateUserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.UserId)
                    .HasColumnType("varchar(36)")
                    .HasDefaultValueSql("''")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.UserName)
                    .HasColumnType("varchar(50)")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.ValidDate)
                    .HasColumnType("datetime")
                    .HasComment("截止日期");

                entity.Property(e => e.VendorId)
                    .HasColumnName("VendorID")
                    .HasColumnType("varchar(36)")
                    .HasComment("供应商ID")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");

                entity.Property(e => e.VendorName)
                    .HasColumnType("varchar(100)")
                    .HasComment("供应商名称")
                    .HasCharSet("utf8")
                    .HasCollation("utf8_general_ci");
            });

            OnModelCreatingPartial(modelBuilder);
        }

        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
    }
}
